prepare("select * from outmain where (dateout BETWEEN '$date1' and '$date2') and department ='$dept'") ;
$getd->execute() ;
}
else
{
$getd = $DBcon->prepare("select * from outmain where dateout BETWEEN '$date1' and '$date2'") ;
$getd->execute() ;
}
while($row = $getd->fetch(pdo::FETCH_ASSOC))
{
//$tcost[] = $row['amount'] ;
$sales[] = $row['inventout_id'] ;
$salesdept[] = $row['department'] ;
}
?>
| SN |
INVENTOUT ID |
CATEGORY |
ITEMS |
MEASURE |
QUANTITY |
prepare("select * from outdetails where inventout_id = '$sid'") ;
$gd->execute() ;
$ct = 0 ;
while($row1=$gd->fetch(pdo::FETCH_ASSOC))
{
$ct++ ;
$sd = $salesdept[$x] ;
?>
|
|
|
|
|
|
| |
|
|
|
|
|